MCQs

Filter MCQs

Search

Categories

Subcategories

Difficulty

Clear

Available Questions

Showing 231 - 240 of 1111 Questions

To drag a selected range of data to another worksheet in the same workbook, use the

A Tab key
B Alt key
C Shift key
D Ctrl key
Correct Answer

Option D: Ctrl key


Discussion

The default header for a worksheet is

A Your name
B The date and time
C None
D The sheet tab name
Correct Answer

Option C: None


Discussion

When you group worksheets

A You can enter variable data on multiple worksheets at one time
B You can print more than one worksheet at a time
C You can enter common data, formats, and formulas on multiple worksheets at one time
D b, and c
Correct Answer

Option D: b, and c


Discussion

Data marker on a chart are linked to data points in a worksheet, therefore,

A You can automatically apply formatting to a data series
B You can change the position of a data marker and automatically change the data point value in the worksheet
C You can change a data print value and automatically are draw the chart
D a and b
Correct Answer

Option B: You can change the position of a data marker and automatically change the data point value in the worksheet


Discussion

which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?

A Workday
B Date
C Networkdays
D All of the above
Correct Answer

Option C: Networkdays


Discussion

This type of software is similar to an accountant’s worksheet

A Word processing
B Database
C Spreadsheets
D Graphics
Correct Answer

Option C: Spreadsheets


Discussion

You can not link Excel worksheet data to a Word document

A With the right drag method
B With a hyperlink
C With the copy and paste special commands
D With the copy and paste buttons on the standard toolbar
Correct Answer

Option D: With the copy and paste buttons on the standard toolbar


Discussion

You can zoom a worksheet

A With the mouse pointer in Print Preview
B With the zoom button on the Print Preview toolbar
C With the Zoom command on the view menu
D All of the above
Correct Answer

Option D: All of the above


Discussion

Excel uniquely identifies cells within a worksheet with a cell name

A Cell names
B Column numbers and row letters
C Column letters and row numbers
D Cell locator coordinates
Correct Answer

Option C: Column letters and row numbers


Discussion

The auto calculate feature

A Can only add values in a range of cells
B Provides a quick way to view the result of an arithmetic operation on a range of cells
C Automatically creates formulas and adds them to a worksheet
D A and c
Correct Answer

Option B: Provides a quick way to view the result of an arithmetic operation on a range of cells


Discussion



WhatsApp Support