Web dev quiz

the entire Excel file (.xlsx). One workbook can hold many worksheets

Workbook

A single page of cells inside a workbook, shown as a tab at the bottom of the screen

Worksheet (sheet)

The address of a cell, made of its column letter and row number (example:C7)

Cell reference

The clickable name at the bottom of the workbook used to switch between worksheets. Tabs can be renamed, colored, reordered, hidden and copied

Sheet tab

The strip of tabs and buttons across the top of Excel (Home, Insert, Data, View, etc).

Ribbon

Bringing data from an outside file into a workbook (Data > From Text/CSV), which creates a refreshable connection

Import

Comma-Seperated Values. A plain-text file where each line is a row and commas seperate the columns

.csv file

A plain-text file. Columns are usually separated by tabs, but can use other characters

.txt file

The character that serparates one column’s data from the next in a text file (comma, tab, semicolon, etc).

delimiter

The box to the left of the formula bar. Type a cell reference or defined name there and press Enter to jump to it

Name Box

A plain-English name assigned to a cell or range (example: Sales data) so you can jump to it or use it in formulas

Defined name (named range)

The dialog (Ctrl+G or F5) that jumps to any cell, range or defined name

Go To

Ctrl+F finds data; Ctrl+H finds it and swaps in something new. Set “Within:Workbook” to search every sheet

Find and Replace

A clickable link in a cell (Ctrl+K) that opens a web page, a file, an email or jumps to a place in the workbook.

Hyperlink

Automatically resizing a row or column to fit its contents (double click the heading boundary)

AutoFit

The exact size of a row or column, set by number through Home > Format

Row height / Column Width

The group of settings controlling how a sheet prints: margins, orientation, and paper size (Page Layout Tab)

Page Setup

The direction a page prints: Portrait (tall) or Landscape (wide)

Orientation

The blank space between the printed content and the edges of the paper

Margins

Text that prints at the top (header) or the bottom (footer) of every page, with left, center, and right sections

Header/ Footer

A ready-made code that fills in automatically when printed, such as &[Page] for the page number or &[File] for the file name

header/footer element

the default, everyday editing view

normal view

shows the sheet as printed pages, with margins and editable header/footers

page layout view

shows where pages will split when printed; drag the blue lines to move breaks

Page Break Preview

Locks rows and or columns in places so they stay visible when you scroll.

Freeze Panes

Divides the window into separately scrollable panels

Split

Opens a second window on the same workbook and tiles the windows so you can see two sheets at once

New Window / Arrange All

A saved snapshot of display and print settings (View > Custom Views) you can reappple at any time

Custom View

The small customizable row of one click buttons above or below the ribbon

Quick Access Toolbar(QAT)

A view (Ctrl+`) that displays the formulas in cells instead of their results.

Show Formulas

The selected range that will print instead of the whole sheet (Page Layout > Print Area)

Print Area

Rows or columns that repeat on every printed pages, usually the heading row

Print titles

Shrinking a printout to fit, such as “Fit Sheet on One Page”

Scaling

Information saved with the file, like Title, Tags and Author (File > Info)

Workbook properties

Finds and removes hidden data and personal information (comments, hidden sheets,properties) before sharing

Document inspector

flags problems for people using screen readers, such as a missing alt text

Accesibility checker

A written description of an image or chart that a screen reader can speak alout

Alt text

warns which features will not work if the file is saved in an older excel format

Compability checker

what file format is .xlsx

standard workbook

what file format is .xlsm

macro enabled

what file format is .xls

legacy 97-2003

what file format is .csv

plain text, one sheet, no formatting

what file format is .pdf

fixed snapshot for sharing