(Blank)
Shortcut to convert a data range into a table?
A. Ctrl + T
B. Ctrl + Shift + T
C. Ctrl + L
D. Alt + T
Answer: Ctrl + T
Which shortcut is best to jump to cell A1 from anywhere?
A. Ctrl + Home
B. Ctrl + End
C. Home
D. Alt + Home
Answer: A. Ctrl + Home
Changing font size mainly improves:
A. Data Security
B. Readability
C. Filtering
D. Sorting
Answer: B. Readability
What does Ctrl + Shift + L do?
A. Creates a chart
B. Adds/removes filters
C. Locks workbook
D. Opens Find box
Answer: B. Adds/removes filters
What is the primary purpose of the Fill Handle?
A. Delete data
B. Repeat data patterns
C. Create charts
D. Protect cells
Answer: B. Repeat data patterns
If I want to freeze 1st row and 1st column, which cell should I freeze in freezing pane?
A. A1
B. B1
C. A2
D. B2
Answer: D. B2
Which shortcut opens the Create PivotTable dialog?
A. Alt + N + V
B. Ctrl + X
C. Ctrl + V
D. Ctrl + Shift + L
Answer: A. Alt + N + V
Slicers are mainly used with:
A. Images
B. Tables and Pivot Tables
C. Text Boxes
D. Shapes
Answer: B. Tables and Pivot Tables
You transpose a 3×5 range. What will be the size of the resulting range?
A. 3×5
B. 5×3
C. 8×8
D. Depends on data type
Answer: 5×3
While editing a formula, what does F4 do?
A. Refresh workbook
B. Convert reference to Absolute/Mixed/Relative
C. Lock worksheet
D. Recalculate formula
Answer: B. Convert reference to Absolute/Mixed/Relative
Which feature is used to create a drop-down list?
A. Data Validation
B. Freeze Panes
C. Chart Design
D. Conditional Formatting
Answer: A. Data Validation
Which statement about Excel Tables is FALSE?
A. Filters are automatically added
B. Formulas auto-fill new rows
C. Pivot Tables always gets updated when source data changes
D. Structured references can be used in formulas
Answer: C. Pivot Tables always gets updated when source data changes
Which shortcut selects the entire current data region?
A. Alt + A
B. Shift + Space
C. Ctrl + Space
D. Ctrl + A
Answer D. Ctrl + A
Which chart type is best for showing trends over time?
A. Pie Chart
B. Doughnut Chart
C. Line Chart
D. Area Chart
Answer: C. Line Chart
Which change does NOT require a Pivot Table refresh?
A. Editing existing source values
B. Adding new rows to the source data
C. Creating a new category in source data
D. Expanding source range
Answer: A. Editing existing source values