Filters
Question type
Study Flashcards

The ________ bar displays information about a selected command or operation in progress.

Correct Answer

verifed

verified

Default margins on an Excel 2013 worksheet are .75" top and bottom.

Correct Answer

verifed

verified

True

A formula is:


A) a number that represents a date and can be the basis of calculations.
B) a combination of cell references,operators,values,and/or functions used to perform calculations.
C) a number that represents a quantity and can be the basis of calculations.
D) entered into a cell by pressing F2.

Correct Answer

verifed

verified

The ________ Toolbar allows a user to quickly save,undo,and redo or repeat commands in Excel 2013.

Correct Answer

verifed

verified

Describe a nonadjacent range,provide an example,and describe how to select a nonadjacent range.

Correct Answer

verifed

verified

A nonadjacent range contains two or more...

View Answer

Formatting data makes it difficult to read and tends to obscure meaningful details.

Correct Answer

verifed

verified

When B5 is the active cell and you press Ctrl+Enter,what happens?

Correct Answer

verifed

verified

The label,value,or f...

View Answer

Column headings or row labels can be repeated on multiple-page printouts using the Print Titles Page Setup option.

Correct Answer

verifed

verified

In Excel 2013,it is only possible to add a new worksheet when the workbook is created.

Correct Answer

verifed

verified

Match the following terms to their meanings:

Premises
range
Copy as Picture command
nonadjacent range
Copy
select all cells in a worksheet
Responses
press Ctrl+A twice
group of adjacent or contiguous cells
default copy option
cannot edit individual cell data
C10:C20 and E10:E20

Correct Answer

range
Copy as Picture command
nonadjacent range
Copy
select all cells in a worksheet

Using the fill handle on a cell containing a formula:


A) cannot complete a sequence of dates in a column.
B) changes the background color of the selected cells to yellow.
C) copies the formula in the active cell to other cells and adapts it based upon the type of cell references in the original formula.
D) has two or more sub-commands related to the command.

Correct Answer

verifed

verified

The wrap text feature in Excel:


A) can be downloaded as an add-on to Excel 2013.
B) enables long formulas to wrap to two or more lines within a single cell.
C) is most useful with very short titles or column headings.
D) enables data to appear on two or more lines within a cell.

Correct Answer

verifed

verified

D

To display a different worksheet click the sheet ________ at the bottom of the workbook window.

Correct Answer

verifed

verified

An input area is defined as:


A) a range of cells containing results based on the output area.
B) a display of the name of a worksheet within a workbook.
C) a range of cells containing values for variables used in formulas.
D) the active cell within a workbook.

Correct Answer

verifed

verified

An output area is defined as:


A) a region of a worksheet with formulas dependent on values from an input area.
B) a display of the range name and tab name within a workbook.
C) a range of cells containing values for variables used in formulas and functions within a worksheet.
D) the active cell on an active worksheet.

Correct Answer

verifed

verified

A

Why would you want to use the Increase Decimal or Decrease Decimal buttons on the Home tab?

Correct Answer

verifed

verified

Use Increase Decimal or Decrease Decimal...

View Answer

How do the Comma,Accounting,and Currency formats differ?

Correct Answer

verifed

verified

The Comma format includes the comma as a...

View Answer

Match the following terms to their meanings:

Premises
spreadsheet
Title bar
worksheet
Ribbon
workbook
Responses
electronic file that contains a grid of columns and rows
contains file name and software name
spreadsheet that contains formulas,functions,values,etc.
commands organized into groups
file containing related worksheets

Correct Answer

spreadsheet
Title bar
worksheet
Ribbon
workbook

Adjust the column ________ to accommodate the widest entry in a column.

Correct Answer

verifed

verified

A range:


A) cannot be selected with the mouse.
B) is the numbers that fall between the smallest and largest in a formula or function.
C) is another word for the active worksheet.
D) refers to a group of adjacent or contiguous cells.

Correct Answer

verifed

verified

Showing 1 - 20 of 100

Related Exams

Exam 1

Office Fundamentals and File Management

100 Questions

Exam 3

Word: Document Presentation: Editing and Formatting

100 Questions

Exam 4

Word: Document Productivity: Working With Tables and Mail Merge

100 Questions

Exam 5

Word: Collaboration and Research: Communicating and Producing Professional Papers

100 Questions

Exam 6

Word: Desktop Publishing and Graphic Design: Creating a Newsletter, working With Graphics, and Linking Objects

100 Questions

Exam 7

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

100 Questions

Exam 8

Word: Document Automation: Forms,macros,and Security

100 Questions

Exam 9

Word: Word and the Internet: Web Page Creation and Enhancement, and Blogs

104 Questions

Exam 10

Power: Introduction to Powerpoint: Creating a Basic Presentation

108 Questions

Exam 11

Power: Presentation Development: Planning and Preparing a Presentation

111 Questions

Exam 12

Power: Presentation Design: Illustrations and Infographics

102 Questions

Exam 13

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

100 Questions

Exam 14

Power: Infographics: Creating Text Charts, tables, and Graphs

100 Questions

Exam 15

Power: Interactivity and Advanced Animation: Engaging the Audience

100 Questions

Exam 16

Power: Customization: Customizing Powerpoint and the Slide Show

100 Questions

Exam 17

Power: Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

100 Questions

Exam 19

Excel: Formulas and Functions: Performing Quantitative Analysis

100 Questions

Exam 20

Excel : Charts: Depicting Data Visually

100 Questions

Exam 21

Excel: Datasets and Tables: Managing Large Volumes of Data

100 Questions

Exam 22

Excel: Subtotals, Pivot-tables, and Pivot-charts

103 Questions

Exam 23

Excel : What-If Analysis

103 Questions

Exam 24

Excel: Specialized Functions

103 Questions

Exam 25

Excel: Statistical Functions

103 Questions

Exam 26

Excel : Multiple-Sheet Workbook Management

103 Questions

Exam 27

Excel: Imports, web Queries, and Xml

103 Questions

Exam 28

Excel : Collaboration and Workbook Distribution

108 Questions

Exam 29

Excel: Templates, styles, and Macros

103 Questions

Exam 30

Access : Introduction to Access: Finding Your Way Through an Access Database

100 Questions

Exam 31

Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

100 Questions

Exam 32

Access: Customize,analyze,and Summarize Query Data: Creating and Using Queries to Make Decisions

100 Questions

Exam 33

Access: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

100 Questions

Exam 34

Access: Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

100 Questions

Exam 35

Access : Action and Specialized Queries: Moving Beyond the Select Query

100 Questions

Exam 36

Access: Advanced Forms and Reports: Moving Beyond the Basics

100 Questions

Exam 37

Access: Get Connected: Exchanging Data Between Access and Other Applications

100 Questions

Exam 38

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

100 Questions

Show Answer