study guide 2 pls21

0.0(0)
studied byStudied by 0 people
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/33

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

34 Terms

1
New cards

All of the following are language-based word processors except

a. LaTex

b. HTML

c. microsoft word

c. microsoft word

2
New cards

Alignment option in which text in the paragraph is on the right hand side of the left margin, and the right margin is uneven

 a. Left Align

 b. Justify

 c. Right Align

 d. Center

 a. Left Align

3
New cards

Which of the following offers users the greatest flexibility?

 

a. LibreOffice Writer

 

b. Google Doc

 

c. Apple Pages

 

d. Microsoft Word

b. Google Doc

4
New cards

Readability Statistics is an advanced feature of _____________________

 

a. Microsoft Word

 

b. Google Doc

 

c. NotePad

 

d. Apple Pages

a. Microsoft Word

5
New cards

Which of the following word processing solutions is best suited for figures and equations?

 

a. Microsoft Word

 

b. Notepad

 

c. LateX

 

d. Apple Pages

c. LateX

6
New cards

Which of the following spreadsheet applications is best suited for a user who does not own an Apple computer, has no background in programming and has no funds to purchase a spreadsheet application?

 

a. LibreOffice Calc

 

b. Microsoft Excel

 

c. Apple Numbers

 

d. Google sheets

d. Google sheets

7
New cards

Which of the following terms DOES NOT refer to a typical element of a spreadsheet?

 

a. Formula

 

b. Sheet

 

c. Kernel

 

d. Cell

c. Kernel

8
New cards

All of the following are necessary for a Vlookup function to work effectively except______________

 

a. Apply absolute cell referencing for lookup table range

 

b. Sort lookup table in alphabetical order (A-Z)

 

c. Place lookup values must in in the first column in the lookup table

 

d. Remove absolute cell referencing for lookup table rage

b. Sort lookup table in alphabetical order (A-Z)

9
New cards

What is the chronologic order in which these spreadsheet software were developed?

 

a. VISICALC--->LOTUS 1-2-3--->Microsoft Excel

 

b. LOTUS 1-2-3-->VISICALC---->Microsoft Excel

 

c. VISICALC---->Microsoft Excel-->LOTUS 1-2-3

a. VISICALC--->LOTUS 1-2-3--->Microsoft Excel

10
New cards

In which of the following situations would you be MOST likely to use spreadsheet software?

 

a. Preparing a large group of customized documents to be sent by email

 

b. Preparing a budget

 

c. Preparing a memo

 

d. Preparing a customer address book

b. Preparing a budget

11
New cards

VLookup tables are organized in_____________________

 

a. Rows

 

b. Grid

 

c. Columns

c. Columns

12
New cards

Pivot tables are a proprietary feature unique to Microsoft Excel.

 

a. True

 

b. False

b. false

13
New cards

Alignment option in which text in the paragraph is on the lefthand side of the right margin, and the left margin is uneven

 

a. Right Align

 

b. Justify

 

c. Center

 

d. Left Align

a. Right Align

14
New cards

What is a software application suite?

 

a. An application suite is a drive

 

b. An application suite is a collection of files

 

c. An application suite is a file storage

 

d. An application suite is a collection of computer programs

d. An application suite is a collection of computer programs

15
New cards

Alignment option that adds additional space between words so that both the left and right margins are even

 

a. Center

 

b. Right Align

 

c. Left Align

 

d. Justify

d. Justify

16
New cards

All of the following Word Processing solutions are suited for effective styles except______________

 

a. Libre Office Writer

 

b. Microsoft word

 

c. Notepad

 

d. Apple Pages

c. Notepad

17
New cards

The first spreadsheet software represented a new way of thinking about using computers in that:

 

a. spreadsheets allowed for organization of numerical data in tabular format

 

b. spreadsheets provided a way for artificial intelligence to analyze large amounts of data, which was previously unavailable

 

c. spreadsheets allowed for fast manipulation of numerical data previously unavailable at the time

 

d. spreadsheets do not flow in the sequential and algorithmic order like traditional computer programs at the time

d. spreadsheets do not flow in the sequential and algorithmic order like traditional computer programs at the time

18
New cards

Which of the following word processing solutions is best suited for typesetting and publishing large scientific documents?

 

a. Microsoft Word

 

b. Notepad

 

c. TextEdit

 

d. LateX

d. LateX

19
New cards

Which of the following common software types allows users to create and manipulate text-based documents?

 

a. Database

 

b. Spreadsheet

 

c. Photo editing

 

d. Word processing

d. Word processing

20
New cards

All of the following proprietary  except_______________________

 

a. Apple Numbers

 

b. Microsoft Excel

 

c. Google sheets

c. Google sheets

21
New cards

Which of the following does modern spreadsheet software typically replace?

 

a. Database

 

b. Accounting Tables

 

c. Tables

 

d. Paper ledger

d. Paper ledger

22
New cards

Which of the following spreadsheet applications offered users Graphical User Interface (GUI)?

 

a. VISICALC

 

b. Microsoft Word

 

c. Lotus 1-2-3

 

d. Microsoft Excel

d. Microsoft Excel

23
New cards

Which of the following spreadsheet applications is best suited for a user who does not own an Apple computer, has no background in programming and has no funds to purchase a spreadsheet application?

 

a. Microsoft Excel

 

b. Google sheets

 

c. LibreOffice Calc

 

d. Apple Numbers

b. Google sheets

24
New cards

All of the following are GUI based word processors except___________________

 

a. HTML

 

b. Microsoft Word

 

c. Libre Office Writer

 

d. Apple Pages

a. HTML

25
New cards

Which of the following word processing solutions is best suited for typesetting and publishing large scientific documents?

 

a. Notepad

 

b. LateX

 

c. Microsoft Word

 

d. TextEdit

b. LateX

26
New cards

Which of the following offers users the greatest flexibility?

 

a. Google Doc

 

b. Microsoft Word

 

c. Apple Pages

 

d. LibreOffice Writer

d. LibreOffice Writer

27
New cards

Word processing based on markup languages adds formatting to text primarily through keyboard shortcuts.

 

True

 

False

false

28
New cards

Which of the following common software types allows users to create and manipulate text-based documents?

 

Spreadsheet

 

Photo editing

 

Database

 

Word processing

Word processing

29
New cards

HLookup tables are organized in_____________________

 

Grid

 

Columns

 

Rows

c. rows

30
New cards

Which of the following represents the correct format for absolute cell referencing?

 

$A12

 

$A$12

 

A$12

 

A$12$

$A$12

31
New cards

Readability Statistics is an advanced feature of _____________________

 

Microsoft Word

 

Google Doc

 

NotePad

 

Apple Pages

Microsoft Word

32
New cards

Benefits of software application suites include all of the following EXCEPT:

 

reasonable pricing

 

common User Interface

 

takes up a lot of space

 

integrated products are designed to work together

common User Interface

33
New cards

Which of the following applications offers the most flexibility in terms customization?

 

Google sheets

 

LibreOffice Calc

 

Apple Numbers

 

Microsoft Excel

LibreOffice Calc

34
New cards

A computerized version of a ledger is a _____________________

 

Table

 

Sales receipt

 

Spreadsheet

 

Check Register

Spreadsheet