Search Header Logo

W6 18/04

Authored by Xinh Trang

Computers

University

W6 18/04
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Mia inserted a plain table in a worksheet. She wants to change the black borders and white fill to make the table more attractive and easier to use. What is the quickest way for her to change the appearance of the table?

Change the shading and border colors of the cells

Filter the table

Change the table style

Convert the table to a range

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A(n) ___ is a range of data Excel treats as a single object that can be managed independently from other data in the workbook.

Table

Outline

Summary

Dashboard

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Josh wants to insert a column in an Excel table to add the values from two other columns. Which of the following methods can he use to insert a table column?

Click a column header and then click the Insert button on the Home tab

Right-click a column header, click Format Cells on the shortcut menu, and then click Add New Column

Click a column header, click the filter arrow, and then click Insert

Double-click a column header and then click Insert on the shortcut

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you hide the filter buttons in a table?

Click the Filter Button check box in the Table Styles Options group

Clear the filters from the table

Right-click a filter button and then click Remove

Click a filter button and then click Hide

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Tracy created a table where the odd and even-numbered columns are formatted differently. She wants to remove this formatting. What setting should she change?

Banded columns

Calculated columns

Odd/Even columns

First column

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Helen wants to resize slicer buttons to exact dimensions. What can she use to do so?

Slicer Settings button in the Slicer group

Height and Width boxes in the Buttons group

Slicer Styles gallery

Slicer Size box in the Slicer group

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Leigh-Ann used a slicer to filter a table on the Department field. Which of the following buttons should she click on the slicer to redisplay data for all the departments?

Multi-Select button

Clear Filter button

Slicer Settings button

Slicer Styles button

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?