Excel Chapter 3

Excel Chapter 3

KG - Professional Development

9 Qs

quiz-placeholder

Similar activities

Database

Database

7th - 8th Grade

12 Qs

FINMODE Refresher

FINMODE Refresher

University

14 Qs

Excel Basics

Excel Basics

10th Grade

8 Qs

Introduction to Access

Introduction to Access

5th - 12th Grade

10 Qs

Final Exam Semester 1

Final Exam Semester 1

9th - 12th Grade

11 Qs

Breathtaking Admin and IT Quiz :)

Breathtaking Admin and IT Quiz :)

8th Grade

10 Qs

MOS Word 2016 Learn by Doing Part 4 Working with Tables

MOS Word 2016 Learn by Doing Part 4 Working with Tables

8th - 12th Grade

12 Qs

Excel 2019 Formulas and Functions

Excel 2019 Formulas and Functions

8th - 12th Grade

10 Qs

Excel Chapter 3

Excel Chapter 3

Assessment

Quiz

Business

KG - Professional Development

Easy

Created by

Joseph Foster

Used 12+ times

FREE Resource

9 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than _____ values.

logical

constant

consistent

calculated

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The Copy button copies the contents and format of the source area to the office _____, a reserved place in the computer's memory.

Ribben

Clipboard

Folder

File

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Rotated text also allows you to fit more text into a smaller column width.

True

False

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A relative cell reference instructs Excel to adjust the cell reference as it copies to to the destination area.

True

False

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The <= comparison operator means less than or equal to.

True

False

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Excel includes four types of Sparkline charts: Line, Column, Win/Lose, and Stock.

True

False

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You can select nonadjacent ranges using the SHIFT key.

True

False

8.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When you rest the mouse pointer over a chart item, such as the legend, Excel displays a chart tip containing the name of the item.

True

False

9.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Changing the order of sheets in a workbook allows you to position the most important worksheets first.

True

False