0
Login

MS Excel

Filter MCQs

Search

Categories

Subcategories

Difficulty

Clear

Available Questions

Showing 171 - 180 of 336 Questions

69 Details Computer Science MS Excel Easy

A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?

A Go to File-Save As – Save As Type – Excel worksheet
B Right click on the spreadsheet tab and select DELETE
C Right click on the spreadsheet and select Insert – Entire Column
D None of above
Correct Answer

Option B: Right click on the spreadsheet tab and select DELETE

Discussion
71 Details Computer Science MS Excel Easy

The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ….

A G1-G10
B B1.G10
C B1;G10
D B1:G10
Correct Answer

Option D: B1:G10

Discussion
72 Details Computer Science MS Excel Easy

You can edit existing Excel data by pressing the

A F1 key
B F2 key
C F3 key
D F4 key
Correct Answer

Option B: F2 key

Discussion
78 Details Computer Science MS Excel Easy

“Qtr 1, Qtr 2, Qtr 3” is an example of a

A Formula
B Function
C Series
D Syntax
Correct Answer

Option C: Series

Discussion
65 Details Computer Science MS Excel Easy

What is an expression that tells how the numbers in a determined set of cells are to be calculated?

A Formula
B Field
C Data
D Query Correct Answer:
Correct Answer

Option A: Formula

Discussion
64 Details Computer Science MS Excel Easy

What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed

A Format Report
B Pivot Table
C Refresh Data
D Show Detail
Correct Answer

Option C: Refresh Data

Discussion
62 Details Computer Science MS Excel Easy

What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?

A F3
B F5
C F7
D F11
Correct Answer

Option D: F11

Discussion
78 Details Computer Science MS Excel Easy

The autofill feature

A Extends a sequential series of data
B Automatically adds a range of cell values
C Applies a boarder around selected cells
D None of above
Correct Answer

Option A: Extends a sequential series of data

Discussion
56 Details Computer Science MS Excel Easy

If you press …., the cell accepts your typing as its contents.

A Enter
B Ctrl + Enter
C TAB
D Insert
Correct Answer

Option A: Enter

Discussion
66 Details Computer Science MS Excel Easy

You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.

A Edit
B Insert
C Format
D Tools
Correct Answer

Option D: Tools

Discussion


Computer Science

WhatsApp Support