NEW
Font size
WorksheetsCI POP QUIZ - AUG 2021
Total questions: 10
Worksheet time: 3mins
To select an entire column in MS Excel, press?
CTRL + S
CTRL + Arrow key
CTRL + C
None of the above
How do you rearrange the data in ascending or descending order?
Data, Sort
Data, Table
Data, Form
Data Subtotals
In Excel, you can sum a large range of data by simply selecting a tool button called?
Auto format
Auto sum
AutoFill
Auto correct
A macro is a part of a conditional format?
TRUE
FALSE
To save a VBA project with an Excel workbook, the workbook must be saved as what type of file?
xlv
xlsx
xlsv
xlsm
What is the shortcut keystroke to debug VBA code one line at a time?
Alt+F5
Ctrl+F8
F8
F5
What do you need to select to set the developer mode?
Show visual basic options menu
Show developer tab in the Ribbon
Show macro code settings
Show mini toolbar on selection
Excel stores its documents as files called?
Worksheets
Sheet tabs
Workbooks
Books
How do you copy the cell above without using copy paste or drag and drop?
Ctrl + C + P
Ctrl + '
Alt + P
None of the above
Which of the following is not a chart type in Excel?
Bar Chart
Pie Chart
Pin Chart
Line Chart
