Excel: Module 1

On a PC. which browser command is used to install Office in Edge? Run Setup Save File Install

Run

What is the very first step towards using Excel on a new computer? - installing Excel - activating Excel - opening Excel - downloading Excel

downloading Excel

Which of the following can be changed as part of a cell Style? row size column size font size cell size

font size

Which element of a table is represented by a number? rows cells header columns

rows

What term BEST describes Excel? word processor database tool spreadsheet cloud computing

spreadsheet

What term refers to general ready-made formatting options built into Excel? cases styles fashions types

styles

Which of these is an example of a formatting tool? Excel importing CSV files Excel underlining font in a cell Excel's search tools Excel's online help tools

xcel underlining font in a cell

This course is based on which version of Excel? 2020 2019 2016 2013

2019

Which type of company is likely to use Excel? - Large companies with hundreds of employees - Small companies with relatively few employees - Companies that hand their own payroll - Almost every type of company is likely to use Excel

Almost every type of company is likely to use Excel

What is an example of a number format? Portrait orientation Dates Names Right alignment

Dates

Chelsea accidentally added a sheet to the wrong workbook. How can she MOST easily move the sheet to the correct workbook? - Drag and drop the sheet tab to the correct workbook. - Right click the tab and select Move to New Workbook - Select the sheet and select Home > Editing > Replace - Select the sheet and press the PRT SC key, then paste it to the correct workbook.

Drag and drop the sheet tab to the correct workbook.

What aspect of Excel makes it well-suited to businesses who create visual-heavy reports? - Excel can reference cells in different places. - Excel can recognize data as percentages. - Excel data can quickly be added to charts and graphs. - Excel can store word data as well as numbers.

Excel data can quickly be added to charts and graphs.

Deleting a row or column will remove the data in the cells but preserve the layout and formatting. True or False

False

Excel is about 15 years old, created in the early 2000s. True or False

False

Excel's major limitation is that a spreadsheet can only hold up to 2,560 rows of data. True or False

False

If a person is interacting with a modern computer for the first time and doesn't know whether or not it has Excel on it, they can find out with a quick internet search using any browser. True or False

False

Mac and PC users use different websites to download and install Office. True or False

False

One useful application of styles is that they quickly resize columns or rows. True or False

False

Carlos is searching through an Excel document to find all the phone numbers that contain the area code "949." Editing restrictions prohibit him from using the Sort command. What button should he expect to press frequently if he is doing this via Excel's search tools? Zoom To... Follow And Then... Find Next

Find Next

Eloise wants Excel to set the data in a column to specifically be formatted as zip codes. Where should she look for the option to do so? Home > Font Home > Number Design > Properties Data > Data Types

Home > Number

Maria would like to include a footer in her document. What Excel menu option should she use? Home > New Insert > Text Add > Header/Footer Edit > Margin

Insert > Text

Which of these statements is true about bulk-inserting data? - It can be done with a copy and paste command. - It can't be done across spreadsheets. - It can't be done via drag and drop. - It removes all formatting of the original data

It can be done with a copy and paste command.

What is one reason that is it useful to learn how to use Excel? - Many skills Excel uses can be applied to other types of software. - Very few adults know even the basics of how to use Excel, so it's a rare, marketable job skill. - Excel is available only in English, so it improves international job performance. - Excel is one of the few free spreadsheet applications available online.

Many skills Excel uses can be applied to other types of software.

Which version of office is subscription-based, rather than a one-time purchase? Office 2019 Office Access Office Cloud Office 365

Office 365

Gregory wants to set up his worksheet with dimensions suitable for a landscape, not a portrait. Which tab should he turn to? Home Page Layout Design Insert

Page Layout

Marcia wants to set up her spreadsheet so that the rows alternate color between white and blue. Her spreadsheet currently looks like this: Home > Font Insert > Add-ins Page Layout > Themes View > Workbook Views

Page Layout > Themes

Estelle needs to add a new row of data in between two rows in an existing spreadsheet. What should she do? - Click on the cell, then select Insert > New Row. - Double click on the bottom row's label. - Right click on one of the existing row numbers and select Insert. - Click on the number of the bottom row, then drag and drop downwards.

Right click on one of the existing row numbers and select Insert.

Lupe's spreadsheet of student information accidentally includes their social security numbers—private data she does not want to share! How can she quickly fix and remove the entire offending column from the spreadsheet? - Select the column and press the Delete key. - Select the column and press the Backspace key. - Select the column, right click, then select Delete. - Click the Data tab and select the Erase button

Select the column, right click, then select Delete.

A single spreadsheet can contain thousands of columns or rows. True or False

True

Excel shares many formatting tools with text programs like Word. True or False

True

Excel spreadsheets aren't limited to text; they can also contain illustrations, graphics, and charts. True or False

True

Excel's Find & Select tool not only allows you to search for content, it also allows you to easily replace it with something else. True or False

True

For drag and drop copying, users will see a pointer on a PC and a hand icon on a Mac. True or False

True

When you open an installed, activated copy of Excel, you have two general options on the first screen you see: creating a new workbook or opening an existing one. True False

True

Mario needs to quickly locate a specific string of text in a large spreadsheet. What icon should he look for to help him find the command that allows this? a microscope a telescope a funnel a magnifying glass

a magnifying glass

What is the equivalent of a "page" in Excel? a cell a worksheet a spreadsheet a workbook

a worksheet

When is Office activated? - when a user signs in to their Microsoft account - when a user downloads the program to their local computer - when a user installs the program to their local computer - after a user first opens the application

after a user first opens the application

What is an example of a popular non-business use of Excel? - large-scale data analysis - project management - storage and data entry - calendars and schedules

calendars and schedules

Which element of a table is represented by a combination of letters and numbers, for example A1? rows cells worksheet columns

cells

What does CSV stand for? currently selected value comma-separated values colon-separated version common standard versions

comma-separated values

Meagan wants to create a budgeting spreadsheet where all negative numbers stand out. What can she use to quickly turn all cells with negative numbers red? Boolean formatting optional formatting custom formatting conditional formatting

conditional formatting

What is an example of a task to which Excel is especially well-suited? - creating a flyer advertising an event - creating a budget of income vs. expenses - telling a short, but interesting, story - visually representing abstract ideas, like "what is the color purple"

creating a budget of income vs. expenses

What is the Find command used to look up? data themes rows styles

data

Melanie wants to quickly resize a row in her spreadsheet. What's the fastest method of doing this? - dragging and dropping the border of the row's number - selecting a cell in the row, then dragging and dropping the small square in the bottom right - right clicking the row number and selecting Format Cells - select the row's number, then choose Design > Resize Table

dragging and dropping the border of the row's number

What is an example of something that can be inserted into Excel using the Insert tab? themes templates images delimiters

images

What website should users visit to download Excel? excel.com word.com office.com spreadsheet.com

office.com

Which of these lines of text represents properly formatted CSV? one, two, three one two three one two three one; two; three

one, two, three

Opal needs to create a spreadsheet that, when printed, fits on a page that is wider than it is high. What does she need to change? orientation theme style numbering

orientation

Marcos has a health issue that prevents him from dragging and dropping easily. How can he change the columns in a spreadsheet to a very precise size? - double click the column's letter to auto-resize - right click on the column's letter and select Column Width - select the columns' letter, then choose Home > Alignment > Column Width - select any cell in the column, then right click and choose Format Cells

right click on the column's letter and select Column Width