Which of the following commands is used to insert a cell into a worksheet?

The Insert command in the Cells group on the Home tab.

The Format command in the Cells group on the Home tab

The Format Painter command in the Clipboard group on the Home tab

The Format command in the shortcut menu when you right-click a cell

You don't like the cell style you just applied. Which of the following is the least effective way to remove or replace the style?

Apply another style to the cell.

Apply the Normal style to the cell.

Which of the following statements describes how to increase or decrease a column's width?

Drag the boundary next to the column heading

Right-Click anywhere in the column and select format cells

Select a Width setting in the Scale to Fit group on the Page layout tab.

Which of the following statements describes how to unhide a hidden row or column?

Select the rows/columns before and after the hidden rows/columns and the right-click and select Unhide.

Select a range of cells in the row or column, right-click, and select Unhide.

In which of the following locations are check boxes that you can select to view or print gridlines?

On the Page Layout tab, in the Sheet Options group

On the home tab, in the Cells group

On the Page Layout tab, in the Page Setup group

Which of the following procedures is NOT a way to delete one or more worksheets from a workbook?

Press Ctrl+A to select all cells in the worksheet and then press Delete.

Right-click a worksheet tab and click Delete

Click the Delete drop-down arrow on the home tab and click the Delete Sheet.

Select a group of worksheets, right-click the group, and click Delete.

Which of following statements about hidden and unhidden worksheets is correct?

Excel creates a minimized window for each hidden worksheet.

Unhidden worksheets cannot contain formulas that refer to hidden worksheets.

When you click Find All, the Find and Replace dialog box will show matched contents within hidden worksheets as well as unhidden ones.

A hidden worksheet cannot be inadvertently deleted.

Which of the following statements describes a reason as to why you would need to copy a worksheet within a workbook?

It lets you reuse formats and formulas in a new sheet.

It's the easiest way to make a backup before making changes.

It helps Excel learn where your data ranges are located.

You should keep one worksheet hidden in case of an error.

Which of the following statements describes how to change the color of a worksheet tab?

Right-click the tab and select Tab Color.

On the Page Layout tab, in the Themes group, select Colors.

Use the Fill Color tool on the Home tab.

you cannot change the color of a worksheet tab.

Which of the following steps is a method for hiding a single worksheet in a multi-sheet workbook?

Right-click the worksheet's tab and click Hide.

On the view tab, in the Window group, click Hide.

Select the visible area of the worksheet.

Enter the name of the worksheet in the Hide dialog box.

Which of the following steps is NOT a method for inserting a worksheet into a workbook?

On the Insert tab, click Worksheet.

Click on the New sheet (+) button to the right of the worksheet tabs.

On the home tab, click Insert and then click Insert Sheet.

Right-click a worksheet tab and click Insert, then click Worksheet and click OK.

In order for you to freeze the first column of a worksheet into a frozen pane:

You can click Freeze First Column in the Freeze Panes menu.

All the data in the column must be visible.

The first row of the column must be non-blank.

Duplicate worksheets must also be able to have their first columns frozen.

MOS Excel Quiz 2

Authored by Lorri Arnce

Business

9th - 12th Grade

39 Questions

Used 45+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following calculates the total from the adjacent cell through the first nonnumeric cell by default, using the SUM function in its formula?

AVERAGE

AutoSum

COUNT

MAX

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You want to add a range of cells and then divide by the number of cell entries, determining the mean value of all values in the range. Which function should be used?

MIN

AVERAGE

COUNT

MAX

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You want to calculate the number of nonblank cells in your worksheet. Which function should be used?

SUM

COUNTA

MIN

MAX

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following statements accurately describes the default selection for AutoSum?

You must first make the selection before clicking AutoSum.

By default, AutoSum totals all entries above the cell in which the formula is located, even if the cells contain a mix of numeric and nonnumeric content.

By default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell.

AutoSum does not have a default selection.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The COUNT and MIN functions are examples of which category of functions?

Text

Statistical

Financial

Logical

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The AVERAGE function returns the mean value in a range of selected cells.

True

False

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The COUNT function returns the total number of cells in the selected range that contain both text and numbers.

True

False

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

35 questions

Nature and purpose of business

Quiz

•

11th Grade

40 questions

Review Questions 17.1 – 17.6

Quiz

•

9th Grade - University

41 questions

Accounting Chapter 8 Review

Quiz

•

11th - 12th Grade

40 questions

Organisational Management

Quiz

•

10th Grade

43 questions

Federal Reserve, Money, and Interest (B3&4)

Quiz

•

9th - 12th Grade

44 questions

Business Management I Standard 2.00 Review (v.2019)

Quiz

•

9th - 12th Grade

35 questions

BP Ch. 5 Test

Quiz

•

9th - 12th Grade

43 questions

Game & Simulation Foundations - Sem 2 Exam Review (1)

Quiz

•

9th - 12th Grade

Popular Resources on Wayground

5 questions

This is not a...winter edition (Drawing game)

Quiz

•

1st - 5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

10 questions

Identify Iconic Christmas Movie Scenes

Interactive video

•

6th - 10th Grade

20 questions

Christmas Trivia

Quiz

•

6th - 8th Grade

18 questions

Kids Christmas Trivia

Quiz

•

KG - 5th Grade

11 questions

How well do you know your Christmas Characters?

Lesson

•

3rd Grade

14 questions

Christmas Trivia

Quiz

•

5th Grade

20 questions

How the Grinch Stole Christmas

Quiz

•

5th Grade

Discover more resources for Business

20 questions

Mastering Job Interview Skills

Quiz

•

9th Grade

50 questions

Principles Fall Concepts Review

Quiz

•

9th Grade

MOS Excel Quiz 2

Which of the following calculates the total from the adjacent cell through the first nonnumeric cell by default, using the SUM function in its formula?

You want to add a range of cells and then divide by the number of cell entries, determining the mean value of all values in the range. Which function should be used?

You want to calculate the number of nonblank cells in your worksheet. Which function should be used?

Which of the following statements accurately describes the default selection for AutoSum?

The COUNT and MIN functions are examples of which category of functions?

The AVERAGE function returns the mean value in a range of selected cells.

The COUNT function returns the total number of cells in the selected range that contain both text and numbers.

The MAX function returns the total of all cells in the selected range of cells.

The MIN function returns the smallest value in a range of cells.

You must use the AutoSum button to enter a SUM function - you cannot type it manually in a cell.

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Business