CI POP QUIZ - AUG 2021

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