LBS TRAINING CENTRE

Security Features

  • Encrypted session storage
  • Content protection system
  • Copy/paste prevention
  • Screenshot detection
  • Activity monitoring
Guest User
Restricted Access - LBS Teachers Only
LBS TRAINING CENTRE
Computer Basics Workshop
Only for LBS Teacher
Course:
Basic Computer Skills
Batch Time:
8:00 AM - 8:00 PM
Teacher Name:
Loading...
Last Access:
Just now
LBS TRAINING
Basic Excel Questions
1
What is the extension of Excel files?
ANS: .XLSX
2
What are the main uses of Excel?
ANS:
  • Accounting work
  • Calculation
  • Formulas
  • Data entry
  • Data management
3
How many tabs are in MS-Excel?
ANS: Excel has 8 main tabs:
  • Home
  • Insert
  • Page Layout
  • Formulas
  • Data
  • Review
  • View
  • Help (in newer versions)
4
What is the shortcut key for a new workbook?
ANS: Ctrl + N
5
What is the maximum and minimum number of sheets in Excel?
ANS:
  • Minimum: 1 sheet
  • Maximum: Limited by available memory (theoretically 1,048,576 sheets)
6
How many groups of related commands are in the Home tab?
ANS: 7 groups: Clipboard, Font, Alignment, Number, Styles, Cells, Editing
7
How many groups of related commands are in the Insert tab?
ANS: 6 groups: Tables, Illustrations, Charts, Tours, Sparklines, Filters
8
How many groups of related commands are in the Page Layout tab?
ANS: 5 groups: Themes, Page Setup, Scale to Fit, Sheet Options, Arrange
9
How many groups of related commands are in the Formulas tab?
ANS: 4 groups: Function Library, Defined Names, Formula Auditing, Calculation
10
How many groups of related commands are in the Data tab?
ANS: 5 groups: Get & Transform Data, Queries & Connections, Data Types, Sort & Filter, Data Tools, Forecast
11
How many groups of related commands are in Review and View tabs?
ANS:
  • Review tab: 4 groups (Proofing, Accessibility, Insights, Comments)
  • View tab: 5 groups (Workbook Views, Show, Zoom, Window, Macros)
12
How to total numbers in Excel?
ANS: Use SUM function: =SUM(A1:A10)
13
How to count text in Excel?
ANS: Use COUNTIF function: =COUNTIF(range, "*")
14
What is the shortcut trick for SUM?
ANS: Select cells → Press Alt + =
15
How many rows and columns in Excel?
ANS:
  • Rows: 1,048,576
  • Columns: 16,384 (A to XFD)
16
What are the first and last cells in Excel?
ANS:
  • First cell: A1
  • Last cell: XFD1048576
17
How to rename a sheet?
ANS: Double-click sheet name → Type new name → Press Enter
18
How many default sheets in a new workbook?
ANS: 1 sheet (default setting)
19
How to insert a sheet in Excel?
ANS:
  • Click "+" icon next to sheets
  • OR: Shift + F11
20
How to add columns and rows in Excel?
ANS:
  • Right-click row/column header → Insert
  • OR: Home tab → Insert dropdown
Advanced Excel Questions
21
How to convert numbers to Roman numerals?
ANS: Use ROMAN function: =ROMAN(number)
22
How to add +91 to phone numbers?
ANS:
  1. Select data
  2. Ctrl + 1
  3. Custom format: +91 0#########
23
How to hide blank cells in data entry?
ANS:
  1. Select data
  2. Ctrl + G
  3. Select Blank option → OK
  4. Ctrl + 9
24
3 tricks for number sequence in Excel?
ANS:
  1. Drag fill handle with Ctrl
  2. Use SEQUENCE function: =SEQUENCE(rows)
  3. Enter first two numbers → select both → drag fill handle
25
Shortcut for transposing data?
ANS:
  1. Select heading → Ctrl + C
  2. Select target cell
  3. Alt + E + S
  4. Select Transpose
26
How to sum multiple data amounts?
ANS: Use SUMIFS function: =SUMIFS(sum_range, criteria_range1, criteria1, ...)
27
Shortcut for auto formatting tables?
ANS: Ctrl + T OR Alt + O + A
28
Shortcut key for RANDBETWEEN?
ANS: No direct shortcut, but use: =RANDBETWEEN(bottom, top)
29
Convert month number to month name?
ANS: =TEXT(DATE(2023,month_number,1),"MMMM")
30
How to convert amounts to 10K, 20K format?
ANS:
  1. Select cell
  2. Ctrl + 1
  3. Custom format: 0,"K"
31
Current date and time shortcut key?
ANS:
  • Current date: Ctrl + ;
  • Current time: Ctrl + Shift + ;
32
Insert sheet shortcut key?
ANS: Shift + F11
33
Shortcut to go to next sheet?
ANS: Ctrl + Page Down
34
Shortcut to go to previous sheet?
ANS: Ctrl + Page Up
35
Show formula shortcut key?
ANS: Ctrl + ` (backtick)
36
Shortcut key for Filter and its use?
ANS:
  • Shortcut: Ctrl + Shift + L
  • Use: To quickly filter data based on criteria
37
How to insert multiple rows/columns at once?
ANS:
  1. Select number of rows/columns equal to what you want to insert
  2. Right-click → Insert
38
How to hide data in Excel?
ANS:
  1. Select data
  2. Ctrl + 1
  3. Custom → Type: ;;;
  4. Press Enter
39
How to add "Mr." to all employee names?
ANS:
  1. Select data
  2. Ctrl + 1
  3. Custom → Type: "Mr." @
  4. Press Enter
40
How to use Text to Columns?
ANS:
  1. Select data
  2. Alt + A + E
  3. Press Enter three times
41
How to set Print Area in Excel?
ANS:
  1. Select range
  2. Page Layout tab → Print Area → Set Print Area
42
Excel magic trick for table formatting?
ANS:
  1. Select data
  2. Ctrl + C
  3. Ctrl + T
  4. Benefit: Automatic calculation and formatting
43
How to arrange multiple data in Excel?
ANS: Alt + W + A → Press Enter
44
How to freeze panes and shortcut key?
ANS:
  • View tab → Freeze Panes
  • Shortcut: Alt + W + F + F
45
How to format TAX in superscript?
ANS:
  1. Select text
  2. Press F2
  3. Ctrl + Shift + F
  4. Alt + E
  5. Press Enter
46
How to insert image on employee name?
ANS:
  1. Right-click employee name → Insert Comment
  2. Clear name
  3. Click comment box outline
  4. Right-click → Format Comment
  5. Color and Line → Fill Effects → Picture
  6. Select picture → Insert → OK → OK
47
How to insert automatic serial numbers?
ANS: Use formula: =IF(B3="","",ROW(1:1))
48
Use of Enter, Shift+Enter, Alt+Enter, Ctrl+Enter?
ANS:
  • Enter: Move to next cell below
  • Shift+Enter: Move to previous cell above
  • Alt+Enter: Insert new line within same cell
  • Ctrl+Enter: Fill selected cells with same content
49
What is the Dashboard in Excel?
ANS: A visual display of key metrics and data points using charts, graphs, and tables for quick analysis
50
How to format multiple cells at once?
ANS:
  1. Select cell
  2. Format cell
  3. Press F4 to repeat action
51
Use of Pivot Table and Slicer?
ANS:
  • Pivot Table: Summarize large datasets and create reports
  • Slicer: Visually filter PivotTable data
52
Use of Pivot Chart?
ANS: Visual representation of PivotTable data that updates dynamically with the PivotTable
53
How to convert inches to centimeters?
ANS: Use CONVERT function: =CONVERT(A2,"in","cm")
54
How to convert meters to centimeters?
ANS: Use CONVERT function: =CONVERT(A2,"m","cm")
55
How to create 100 folders at once?
ANS:
  1. Open Notepad
  2. Write: MD Folder1 to MD Folder100 on separate lines
  3. Save as "folders.bat"
  4. Double-click the .bat file
56
How to sort with shortcut key?
ANS:
  1. Select name
  2. Alt + A + S + A
57
How to create auto emoji reaction?
ANS: Use custom format: [Blue]0✔;[Red]-0❌
58
How to protect sheet with password?
ANS:
  1. Review tab → Protect Sheet
  2. Enter password → OK
59
How to create a data entry form?
ANS:
  1. Select heading
  2. Alt + D + O
60
How to make borders with shortcut?
ANS: Alt + H + B + A
Pro Tip: Use F4 to repeat your last action in Excel - this can save you lots of time when applying formatting!
LBS TRAINING CENTRE

Computer Basics Workshop - Proprietary Training Materials

© 2023 All Rights Reserved |