Practice Final Questions 2

Common OS

Which of these is a common Operating System for “general-purpose” computers such as desktops and laptops [Hint: there are 3 correct answers]?

• Windows
• Mac OS X
• Linux
• Android
• HarmonyOS

OS Acronym

What does OS stand for?

• Answer____________________________

OS Required T/F

An Operating System manages hardware resources, provides a user interface, and allows the execution of application software.

• True
• False

Leaf and Child

In a file tree, an arbitrary file named stuff.txt would be considered a…

(Select all that apply)

• Leaf
• Parent
• Child
• Root

Root and Parent

The / directory in a NFS file tree is considered a…

• Root
• Parent
• Child
• Root and Parent
• Root and Child

Child

A child node has a parent.

• True
• False

Leaf

A leaf node has at least one child.

• True
• False

NFS Root

In the NFS File Tree, the topmost node is known as the home directory.

• True
• False

Parent

A parent node has at least one child.

• True
• False

Root

A root node has a parent.

• True
• False

Abs Pathname NFS

An absolute path in the NFS file tree always starts from….

• The root
• My Home directory
• The E 115 course locker
• My current working directory

Abs Rel Pathname Diff & Sim

An absolute pathname begins at the __________ whereas a relative pathname begins at the __________. Both types of path end at the __________.

• root, current working directory, specified file
• current working directory, root, specified file
• root, specified file, current working directory
• current working directory, specified file, root

• None of these

Forward Slash

As you step down a level within a file tree, you place a ____ to denote a change in directory.

• /
• ..
• space
• —

Rel Pathname – Current Dir

What is the relative pathname for your current directory?

• ./
• ../
• ~/
• /
• None of these

Rel Pathname – Home Dir2

Assuming you are in your home directory:

Do ~/ and ./ refer to the same location?

• Yes
• No

Rel Pathname – Parent Dir

What is the relative pathname for your parent directory?

• ./
• ../
• ~/
• /
• None of these

Rel Pathname Start (2)

A relative path in the NFS file tree can start from… (Choose all that apply)

• The root
• My home directory
• The E 115 course locker
• My current working directory

Abs Pathname T/F

This is an appropriate absolute pathname:  ~/MyE115/Test_3

• True
• False

Abs Pathnames T/F2

Absolute path names include the root directory and all directories leading to the specific file or directory.

• True
• False

Pathname Address

Pathnames are like street addresses to where files live.

• True
• False

Rel Pathname T/F

This is an appropriate relative pathname: ~/../.
(Everything after the semi-colon is part of the pathname)

• True
• False

Rel Pathnames T/F2

Relative pathnames describe how to navigate from your current location to a new location.

• True
• False

Dangerous Exe

Which of the following could be a potentially dangerous executable file (a virus)?

• funnypic.exe
• funnypic.jpg
• funnypic.txt
• All of these
• None of these

Accurate Ext

File extensions are always an accurate representation of the file type.

• True
• False

Ext Changes

Users can manually rename a file and change its extension.

• True
• False

Ext Changing

• True
• False

Image in text editor

It is possible to open a .jpg file with a text editor, but you will likely corrupt or destroy the image.

• True
• False

Fields Matching (4)

Please match the following email fields with what they are used for. Write the correct letter (A, B, C, or D) next to each description:

Appropriate Address of Instructor in Email

What is the most appropriate way to address your college instructor in an email, if they have not told you to call them something else?

• First name

• Miss/Mrs./Mr.

• Professor

• Their last name without a title

Appropriate E-mail Address

If John Q. Public wanted to e-mail his E 115 lab instructor about a Homework question, which e-mail address should he use?

• jqpublic@ncsu.edu
• jqpublic@gmail.com
• hot_pants68@hotmail.com
• mr1337guy@aol.com
• All of these are OK to use

Appropriate E-mail Subject2 (3)

Which of the following should you ALWAYS include in the subject of an e-mail to your NC State lab instructors or professors? [Hint: there are 3 correct answers]

• Course letter and number
• Section Number
• Brief Description of the content of your e-mail
• I should leave the subject blank
• Random Numbers

Appropriate E-mail Subject3 (2)

Select the two most appropriate e-mail subjects for a question on Homework 1 from an E 115 student?

• Homework 1 question
• E 115 Section XXX Homework 1 Question
• E 115 Homework 1 Question
• Section XXX HW Question
• None of these

BCC

If CC stands for Carbon Copy, what does BCC stand for?

• Bandwidth Carbon Copier
• Binary Carbon Copy
• Blind Carbon Copy
• Blind Cache Code
• Big Chili Corndog

BCC2

Which of the following fields will send copies of an e-mail to multiple people, without showing the recipients that a third party might have gotten it, perhaps in secret?

• CC
• BCC
• To
• From
• None of these

CC & BCC

If tamarini sends an e-mail to ahphilli, CC’s cmburget and BCC’s e115-005, who will ahphilli see received the e-mail?

• ahphilli, cmburget, e115-005
• ahphilli, e115-005
• cmburget, e115-005
• tamarini
• ahphilli, cmburget

E-mail Subject Elements (3)

Choose the three different parts to an appropriate e-mail subject line.

• Course letter & number
• Section Number
• A long explanation of the contents of your e-mail
• Your Name
• A short description of the reason for your e-mail
• Your Student ID number
• Your Unity ID

Inappropriate E-mail Subject

Which is the most inappropriate subject for a question on Homework 1 from an E 115 student?

• Homework 1 question
• E 115 Section XXX Homework 1 Question
• E 115 Homework 1 Question
• Section XXX HW Question
• They are all equally appropriate

Label & Filter (2)

Which of these features can be implemented in order to automatically categorize incoming emails through your NCSU Gmail account? [Hint: there are 2 correct answers]

• Labels
• Filtering
• Automated replies
• Gmail Chat
• Background Images

NCSU E-mail Site

To access the NCSU email system, which website should you go to?

• gmail.ncsu.edu
• gmail.org
• yahoo.com
• moodle.wolfware.ncsu.edu

Email Domain

An email domain is the part of an email address that comes after the “@” symbol, and it typically represents the mail server that handles the email. What is the required email domain you must send emails from to access staff support in E 115?

• Answer____________________________

Mock E-mail Subject

You have a question about E 115 Homework 1 and want to email your Lab Instructor. Below type an appropriate subject.

• Answer____________________________

Appropriate E-mail Address T/F

It is okay to e-mail your instructor from your unityid@hotmail.com account.

• True
• False

Appropriate E-mail Address T/F2

For the purpose of E 115 (and my other NCSU classes), I should use my personal (non-NCSU) e-mail address.

• True
• False

E-mail Address Elements

Your NCSU email address is comprised of your Student ID number.

• True
• False

Licenses Matching (4)

Match each type of software license with the appropriate definition. Each answer choice is used only once. Write the correct letter (A–D) next to each description:

Freeware

Open source software would fall under which software license, which allows the user to use the full software as they see fit without purchasing it?

• Freeware
• Shareware
• Network
• Buyware
• None of these

Freeware Linux

Under which of the following would a distribution of Ubuntu Linux fall under?

• Freeware
• Shareware
• Network
• Buyware
• None of these

Network License

What type of software license is used by larger companies, which might have hundreds, if not thousands of copies of a particular piece of software?

• Freeware
• Shareware
• Network License
• Buyware
• None of these

Network License2

Which of the following would consider buying a Network License?

• Government Agency
• School/University System
• Corporate World
• All of these
• None of these

Shareware

What type of software license is most similar to a ‘test drive’ of software, so you can use the software before purchasing a full license?

• Freeware
• Shareware
• Network
• Buyware
• None of these

Software Licenses

Which is a type of software license?

• Network License
• Buyware
• Freeware
• Shareware
• All of these

AVD Overview

What is Azure Virtual Desktop (AVD)?

• A Windows environment deployed via Microsoft Azure cloud services for accessing lab software
• A physical lab environment on the Azure cloud

Printing via web

• Papercut
• Packprint
• Pawprints
• Ink Saver
• None of these

Register Devices

To authenticate your computer on the NCSU network, or register your mobile device, which system is utilized?

• sysnews.ncsu.edu
• nomad.ncsu.edu
• www.ncsu.edu
• www.eos.ncsu.edu/e115
• None of These

Reserving a VCL Computer

How can you reserve a VCL computer?

• By logging in to the web-based reservation system and selecting the desired application and operating system
• By calling the IT department and requesting access
• By visiting the physical VCL lab on campus
• By downloading and installing the VCL client software

Unity Resources

Which of the following are resources of any Unity account?

• E-mail
• Nightly backup
• Personal webs pace
• Networked printing
• All of these

Using VCL on MAC

What must be installed before using VCL on a MAC computer?

• Microsoft Remote Desktop
• Adobe Creative Suite
• VMware Fusion
• Google Chrome

VCL

• VCL
• OIT
• ITECS
• Papercut
• EOS

VCL Access

What is the Virtual Computing Lab (VCL)?

• A method of remotely accessing and using University machines
• A physical computing laboratory on campus
• An application for reserving lab equipment
• A campus organization for computer science students

VCL Features

What is a feature of the Virtual Computing Lab (VCL)?

• Easy-to-use remote access from one’s own desktop or mobile computer
• Access restricted to physical computing laboratories
• Only accessible through specialized client software
• Access limited to specific campus departments

VPN Purpose

What is the purpose of a VPN (Virtual Private Network)?

• To securely access campus network resources from off-campus locations
• To increase internet speed
• To block access to certain websites
• To remotely control other computers

Internet Login

Unless you have registered your device, every time you want to login to the internet on NCSU’s campus you have to put in your Unity ID and password.

• True
• False

Storage Space

As an NCSU student, your Unity account gives you space to save documents on school computers.

• True
• False

Leaf Image (2)

Refer to the image of a hypothetical file tree below to answer this question:

Node C is which of the following? [Hint: there are 2 correct answers.]

• Parent

• Child

• Root

• Leaf

Leaf Image (3)

Refer to the diagram of a hypothetical file tree below to answer this question:

Root
├── Alice
│   ├── Document1_Alice.txt
│   └── Letter_Alice.txt
└── Bob
    ├── Resume_Bob.txt
    └── Projects
        └── Project_Bob.txt

Node Project_Bob.txt is which of the following? [Hint: there are 2 correct answers.]

• Parent

• Child

• Root

• Leaf

Parent/Child Image (2)

Refer to the image of a hypothetical file tree below to answer this question:

Node G is which of the following? [Hint: there are 2 correct answers.]

• Parent

• Child

• Root

• Leaf

Root Image (2)

Refer to the image of a hypothetical file tree below to answer this question:

Node A is which of the following? [Hint: there are 2 correct answers.]

• Parent

• Child

• Root

• Leaf

Number of leaves

How many leaves does the following tree have? (put the number in digits)

• Answer____________________________

Knowledge factor

Closed Terminal Reminder

REMINDER: The Final Exam is CLOSED TERMINAL. Consider the following questions as hypothetical scenarios and complete them WITHOUT the use of your Terminal.

cd-mv-rm

There is a folder named final_exam under your home directory on EOS. Please answer the following questions:

1. You are currently in the home directory. Please provide what you would write in the terminal window to enter final_exam directory.
2. You are currently in the home directory. Please provide what you would write in the terminal window to change the name of the folder final_exam to my_exam.
3. You are currently in the final_exam directory. There are two files in the directory: picture.txt and figure.txt. Please provide what you would write in the terminal window to delete picture.txt.

cp: Final Exam

There is a file named final.txt in the E 115 course locker (/mnt/coe/workspace/csc/admin/e115). You are in your home directory.

In the space below, write how you would copy the file to your home directory and then list the contents of your home directory, all without moving from your home directory.

You must use the absolute path of the E 115 course locker. Please provide as many steps as needed.

cd: Final Exam

You are in the NFS file tree and you wish to move from your current directory to the E 115 course locker.

In the space below, write the command you would use.

For credit use only the absolute path name.

• Answer____________________________

mkdir: Final Exam

Regardless of where you are in the file tree, you want to create a directory called Final_Exam. You want this directory to be located in your home directory.

In the space below, write the command you would use.

Use only the relative path name for your home directory for full credit.

• Answer____________________________

script: Final Exam

You are in your home directory.

You wish to create a log file named final.txt that will capture your commands in real time.

In the space below, write what you would type into the terminal window.

• Answer____________________________

unity ID

Your NCSU Unity ID is comprised solely of numbers.

• True
• False

unity ID

Your NCSU Unity ID is comprised solely of numbers.

• True
• False

Log File Information (2)

The log file contains useful information including (Hint: There are 2 correct answers):

• the commands typed into the terminal window
• any mistakes made in the terminal window
• a full how to guide for the terminal window
• all the manual pages available

Saving Log Files

What must you type in the terminal window to save the log file?

• exit
• save
• help
• record

Saving Log Files2

If you did not use the –f option, what must you type to save the log file?

• exit
• save
• help
• record

script -a Function

I am making a log file that is recording my keystrokes in terminal in real time. My file is in my home directory and is called hw.txt.  I accidentally exit my log file prematurely.  Which of the following commands will allow me to begin writing to hw.txt where I left off? 

• script -a ~/hw.txt

• script -f hw.txt

• script -f ~/hw.txt

• script hw.txt

• script -a ~/hw1.txt

script Function

The script command is used to ____

• keep track of how the terminal is feeling today
• create a file full of important course information
• create a log of everything displayed in the terminal window
• create a log of the commands used in the terminal window

script Options (2)

Which of the following options could you use with the script command? Choose all that apply.

• -f

• -a

• -s

• -l

• -n

script Syntax

The proper (full) syntax for the script command is _____

• script –options filename.extension
• script filename
• script
• None of These

script example 1

What would you type into terminal to start a log file named homeworklog.txt? Make sure to follow the E 115 guidelines for starting a log file.

• Answer____________________________

man cd

If the instructions say: “Display the manual page for the change directory command”, which command would you use?

• cd
• man
• script
• pwd

man cp

If you do not remember how to use the cp command, which command would you use to get more information about the cp command?

• help cp
• man cp
• cp
• cp help

man Function

The man command is used to ____

• create a directory
• display the documentation
• change from one directory to another
• tell you where you are located

man Function2

The man command is an important tool to help _____

• understand where you are located
• show the proper syntax of a command
• tell you how to read a manual page
• None of These

man man

What command would give you the manual page for the man command?

• man man
• man woman
• man help
• cp
• attach

man Output

You are likely to get the following output from using the man command:

• Information on the command

• Options that can be used with the command

• Syntax options of the command

• Definition of the command

• All of these

man Syntax

The proper syntax for the man command is _____

• man
• man command
• command
• None of These

man Output T/F

The man command provides output.

• True
• False

cd Function

Which command would you use to make your current working directory the E 115 course locker?

• mv E115
• cd /mnt/coe/workspace/csc/admin/e115
• mv /mnt/coe/workspace/csc/admin/e115
• cd e115
• None of these

cd Function2

The cd command is used to ____

• create a directory
• list the contents of a directory
• change from one directory to another
• tell you where you are located

cd Syntax

The proper syntax for the cd command is _____

• cd destination
• destination
• cd
• None of These

cd www

Your current working directory is ~/.

What will your working directory be after you execute the following command: cd www?

• /www
• ~/www
• ~/www4

ls -a

Which command would only list all of the files in your current directory?

• ls
• ls –a
• ls –l
• ls –al
• ls -la

ls -l

What command lets you see a list of the files in a directory along with their sizes?

• ls -a
• ls -r
• ls -l
• ls –with-file-size

ls Function

The ls command is used to _____

• show you the contents of a directory
• create a file
• open a file
• None of These

mkdir

To create a directory, which command would you use?

• script
• ls
• mkdir
• cd

mkdir 2

If the instructions say: “Create a directory”, which command would you use?

• cp
• rm
• script
• mkdir

mkdir helps

The mkdir command is an important tool to help _____

• create a file
• create a logfile
• create a directory
• None of These

mkdir MyE115

From anywhere in the file tree, which command would create a directory called MyE115 in your home directory?

• mkdir MyE115
• create MyE115
• mkdir ~/MyE115
• create ~/MyE115
• mkdir ~/mye115

mkdir Syntax

The proper syntax for the mkdir command is _____

• mkdir directory
• directory
• mkdir
• None of These

mkdir use

The mkdir command is used to ____

• create a directory
• list the contents of a directory
• change from one directory to another
• tell you where you are located

cp File Syntax

Assuming you are in your home directory, what is the correct syntax to copy the file ~/copy_this.txt to a subdirectory named hold?

• copy copy_this.txt ~/hold
• cp copy_this.txt ~/hold
• copy ~/hold copy_this.txt
• cp ~/hold copy_this.txt

cp File Syntax – General

The proper syntax for the cp command is _____

• cp filename.txt destination
• filename.txt destination
• cp destination
• None of These

cp Function

The cp command lets you  ____

• create a directory
• copy the contents of a directory
• move from one directory to another
• tell you where you are located

rm Directory

Which command would delete the directory MyE115 and all of its contents from anywhere in the file tree? (Note: MyE115 is in your home directory)

• rm MyE115
• rm –rf ~/MyE115
• rm –rf ~/mye115
• rmdir MyE115
• remove MyE115

rm File

Which command would remove the file more_cheezburgers?

• dlt more_cheezburgers
• delete more_cheezburgers
• rm
• delete
• rm more_cheezburgers

rm -f Output T/F

The remove command (with -f option) has output.

• True
• False

rm -rf Usage T/F DELETE THIS?

You should always use the options -rf whenever you use the remove command.  

• True
• False

rm Output T/F CHANGE/DELETE THIS?

The remove command (no options) has output.

• True
• False

Arrow Keys (2)

Which would you use in order to scroll through commands you have already typed? Choose all that apply.

• tab
• space
• up arrow
• down arrow

• None of these can be used

Chaining Character

What character allows you to run two separate commands on one line?

• , (Comma)
• : (Colon)
• ; (Semi-colon)
• / (Forward slash)
• None of these

Chaining Definition

What is the term that describes how a user can run two separate commands, normally on separate lines, on one line?

• Chaining
• Multi-commands
• Concurrent
• Stringing
• None of these

Chaining Example

Which of the following is an example of chaining?

• man zip , man cp
• man zip : man cp
• man zip # man cp
• man zip ; man cp
• man zip + man cp

Chaining Syntax

What is the correct syntax to run two commands, normally on two different lines, on one line?

• mkdir E115, cd E115
• mkdir E115/ cd E115
• mkdir E115: cd E115
• mkdir E115; cd E115
• None of these

Tab

Which would you use in order to complete the name of a long file?

• tab
• space
• up arrow
• down arrow

pwd

If you are lost within the file tree, which command would you use?

• pwd
• ls
• mkdir
• cd

pwd 2

If the instructions say: “Determine your location”, which command would you use?

• cp
• rm
• script
• pwd

pwd Function

If you need to know the path of the current working directory, which of the following commands should you run?

• cwd
• pwd
• which
• wtf

pwd Output

The pwd command prints the __________ path to the current working directory on the screen.

• convoluted
• relative
• gravel
• absolute

pwd Syntax

The proper syntax for the pwd command is _____

• pwd
• pwd location
• location
• None of These

pwd use

The pwd command is used to ____

• create a directory
• list the contents of a directory
• change from one directory to another
• tell you where you are located

pwd Output T/F

The pwd command has output.

• True
• False

Active Cell

Any cell you have selected is known as a(n) _____.

• active cell
• gray cell
• range
• continuous range

• none of these

Active Cell2

In Excel, when you click on a cell what could you refer to it as?

• Active
• Highlighted
• Filled
• Inactive
• None of these

Cont. Range Ex.

What type of range is A10:A242?

• Continuous
• Non-continuous
• Spacious
• Current
• Concurrent

Non-Cont. Range

A grouping of cells that are not next to each other is known as a (n)_____.

• active cell
• continuous range
• non-continuous range
• span

• None of these

Non-Cont. Range Ex.

Which of the following is a non-continuous range?

• A1:A16 , A18:A52
• B1:B16 , B18:B52
• A1:A16 , A18:A57
• B1:A16 , C1:C17
• These are all non-continuous

Non-Cont. Range Key

What keyboard key must you hold while selecting a non-continuous range?

• Ctrl
• Shift
• Alt
• Tab
• None of these

Range

A grouping of cells is known as a(n) _________.

• range
• active cell
• continuous range
• non-continuous range

• None of these

Range Types T/F

Ranges can either be continuous or non-continuous.

• True
• False

$ Constant Value

• Constant Value
• Cost
• Cell Size
• The first cell in a row
• None of these

Named Cell Autofill

Which of these would ensure that the same cell is always referenced, even after using the auto-fill feature?

• Referencing a named cell
• Removing all symbols
• Referencing by A1
• This cannot be done

Not a Formatting Feature

Which of the following is NOT a formatting feature in Excel?

• Numbers
• Font
• Alignment
• Border
• Shading

Format Border

• True
• False

Format Cells

In Excel, you can format numbers, alignment, and font via Format Cells.  

• True
• False

Format Vertical Text

• True
• False

Percentage and Currency Format T/F

It is possible to setup an Excel document so it recognizes percentages and currency.

• True
• False

“Static” Cell Autofill (2)

Which of these would ensure that the same cell is always referenced, even after using the autofill function? Choose all that apply.

• referencing a named cell
• Adding a “$” to the row and column descriptors for a cell (example: $A$1)
• referencing by column-row address (example: A1)
• this cannot be done in Excel

• by clicking on the desired cell

Autofill Formula Down

If I autofill the following formula (=A1*B1) down a spreadsheet starting in C1, what will the formula be in cell C16?

• =A1*B16

• =A16*B16

• =A16*B1

• =C16*D16

Autofill Formula Down2

If I autofill the following formula (=A$1*B1) down a spreadsheet starting at C1, what will the formula be in cell C5?

• =A1*B5

• =A5*B$1

• =A5*B5

• =A$1*B5

Autofill Formula Down3

If I autofill the following formula (=A1*$B1) down a spreadsheet starting at C1, what will the formula be in cell C10?

• =A10*B10

• =A10*$B1

• =A10*$B10

• =A10*B$10

Autofill Formula Down4

If I autofill the following formula (=Tax_2010*B1) down a spreadsheet starting at C1, what will the formula be in cell C124?

• =Tax_2010*B124

• =Tax_2010*$B124

• =A124*B124

• =Tax_2010*B$1

Autofill Function Down5

If you entered =$B1+1 into cell A1 and then used the autofill function on cell A1 down several rows, what would be the formula stored in cell A3?

• =$B3+1
• =$B3+3
• =$B1+1
• =E3+1

• None of these

Autofill Function Down6

If you entered =B$1+1 into cell A1 and then used the auto-fill function on cell A1 down several rows, what would be the formula stored in cell A3?

• =B$3+1
• =B$3+3
• =B$1+1
• =E3+1

• None of these

Autofill Use (4)

Autofill can be used to increment the following type of data [choose all that apply]:

• Formulas
• Functions
• Growth rates
• Places
• Proper names
• Dates

REPEAT Named Cell Autofill

Which of these would ensure that the same cell is always referenced, even after using the autofill function?

• referencing a named cell
• removing all dollar signs (“$”)
• referencing by column-row address (example: A1)
• this cannot be done in Excel

• by clicking on the desired cell

Autofill Handle

The autofill handle is the black box at the bottom of an active cell.

• True
• False

Autofill Use T/F2

Autofill is a tool that provides uniformity through a range and allows you to write one formula instead of an infinite number.

• True
• False

Equal Sign

• =
• y =
• A variable
• f(x):
• None of these are needed

Formula Input

Write the Excel input for the following: F16 plus F25, divided by 2.

• =F16 + F25/ 2
• (F16 + F25)/2
• =(F16 + F25)/2
• =F16*2 + F25/2
• =sum(F16+F25)

Invalid Formula

Which of the following is an invalid formula? [Select all that apply]

• None of these are invalid

• =A2*Tax_rate

• =SUMIF(A1:A10,”>0″)/COUNTA(A1:A10)

• =10*AVERAGE(B10:B17)

Named Cell Formula

Which of the following contains a named reference?

• =A4*B2

• =average(D34:D65)

• =Tax_Income*45

• =6+7

IF Spending Example

I ended up having a few days of vacation for July 4th during my internship. I need to figure out what I can do with my few days off. If I have saved at least $750.00 I can go to Orlando, FL with my friends. If I have saved at least $400.00 I can spend those few days at the beach. If I have saved at least $250.00 I can go home and do some things with my brother and sister. Which of these IF statements will give me the correct result if the amount of money I have saved is stored in cell A1?

• =if(A1>=750, “Go to Orlando”, if(A1>=400, “Go to the Beach”, if(A1>=250, “Go Home”, “You have no money”)))

• =if(A1>=750,Go to Orlando, if(A1>=400, Go to the Beach, if(A1>=250, Go Home, You have no money)))

• if(A1>=750, “Go to Orlando”, if(A1>=400, “Go to the Beach”, if(A1>=250, “Go Home”, “You have no money”)))

• =if(A1>=250,”Go Home”, if(A1>=400,”Go to the Beach”, if(A1>=750,”Go to Orlando”,”You have no money”)))

IF Text Condition

I found out about an event going on in Raleigh during my internship. I want to go to, but I need to make sure that at least one of my friends are free as well as myself. Which function would I use in Excel?

• =and(b1=”Free”,b2=”Free”,b3=”Free”)

• =or(b1=”Free”,b2=”Free”,b3=”Free”)

• =if(b1=”free”,if(or(b2=”Free”,b3=”Free”),”Go to Event”,”Stay Home”),”Stay Home”))

• =and(b1=”free”,b2=”Free”,b3=”Free”)

Nested IF Definition

When you place one or more IF functions inside of another, it is referred to as _______ ?

• twins, triplets, etc.
• combinatorics
• chaining
• teamwork
• nesting

AND

Which Excel function makes it possible to require that all of the conditions are met?

• combinatorics
• ALL ( )
• chaining
• AND ( )
• OR ( )

AND Concert Example

I found out about a concert in Raleigh that is going on while I am working. I want to go to the concert, but I need to make sure that both my friend and I are free for that night. Which function would I use in Excel?

• =and(b1=”Free”, b2=”Free”)

• =or(b1=”Free”, b2=”Free”)

• =if(b1=”Free”,”Go to Concert”,”Can’t Go”)

• =and(b1=”free”,b2=”Free”)

AND Example

Which would you use to see if a restaurant served brunch on Saturdays, in Excel?

• =AND(B10=”Brunch”, C10=”Saturday”)
• =OR(B10=”Brunch”, C10=”Saturday”)
• =MAYBE(B10=”Brunch”, C10=”Saturday”)
• Google

AND2

Which of the following are used if you have two conditions that must both be true?

• nested if
• simple if
• and
• or

• maybe

IF and AND

If there are two or more conditions, and all need to be true, which of the following would work?

• =if(Condition1, Condition2)
• =if(OR(Condition1, Condition2), True, False)
• =if(AND(Condition1, Condition2), True, False)
• =if(AND(Condition1) True, False)

IF and OR

If there are two conditions and only one needs to be true, which of the following would work?

• =if(Condition1, Condition2)
• =if(OR(Condition1, Condition2), True, False)
• =if(AND(Condition1, Condition2), True, False)
• =if(OR(Condition1) True, False)

OR

Which function makes it possible to require that some of the conditions are met?

• combinatorics
• ALL ( )
• chaining
• AND ( )
• OR ( )

OR Example

Which would you use to see if a restaurant had a discount on Mondays or Tuesdays, in Excel?

• =AND(B10=”Monday”, C10=”Tuesday”)
• =OR(B10=”Monday”, C10=”Tuesday”)
• =MAYBE(B10=”Monday”, C10=”Tuesday”)
• Google

OR2

Which of the following are used if you have two conditions and only one must be true?

• nested if
• simple if
• and
• or

CountIF

You want to count the number of gold medals won in a list of medals. Assume your medals are listed in column A from A2 to A100.  Which function would do this?

• =sumif(condition, A2:A100, sumrange)
• =countif(A2:A100, “Gold”)
• =if(cell=”Gold”,True,False)
• =countif(range=”Gold”,True,False)

CountIF Example

Which of the following is valid usage of the COUNTIF( ) function?

• =COUNTIF(E10:E29 > 10)
• =COUNTIF(E10:E29 >= 10)
• =COUNTIF(E10:E29, >10)
• =COUNTIF(E10:E29,”>10”)
• None are correct

CountIF Syntax

What is the correct syntax for a countif statement?

• =countif(condition, range)
• =countif(range, condition)
• =if(count(condition),True,False)
• =if(count(range=condition),True,False)
• =countif(range=condition,True,False)

CountIF2

In your spreadsheet, you want to count the number of times a particular city appears in a customer list. Which is the correct syntax for doing so?

• =SUMIF(condition, range, sumrange)
• =COUNTIF(A2:A5,”London”)
• =IF(C2=”London”,1,2)
• =SUMIF(B2:B25,”>5″)

SumIF

You want to determine the total amount of money given out by award type.  Which function would do this?

• =sumif(range, condition, sum_range)
• =countif(range, condition)
• =if(cell=”Award Type”,True,False)
• =sumif(range=”Award Type”,True,False)

SumIF Example

Which of the following is a valid usage of the SUMIF( ) function?

• =SUMIF(G10:G29, =Monday,D10:D29)
• =SUMIF(G10:G29, =”Monday”,D10:D29)
• =SUMIF(G10:G29, “=Monday”,D10:D29)
• =SUMIF(G10:G29, “Monday”,D10:D29)
• None are correct

SumIF Syntax

What is the correct syntax for a sumif statement?

• =sumif(condition, range, sumrange)
• =sumif(range, condition, sumrange)
• =if(sum(condition),True,False)
• =if(sum(range=condition),True,False)
• =sumif(range=condition,sumrange)

SumIF2

You want to determine the total amount of money spent on red items. Which function would do this?

• =sumif(condition, range, sumrange)
• =countif(range, condition)
• =sumif(range, condition, sumrange)
• =countif(range=”Red”,True,False)

1 Kb in Bytes

Using the software amount (that computers use), how many bytes are in a Kilobyte?

• 1000
• 1024
• 1000^2
• 1,048,576

1 MB in Bits (Equation)

Using the software amount (that computers use), how many bits are in a Megabyte?

• 2000
• 1024^2
• (1024^2) * 8
• 2000 * 8
• 3000

1 MB in Bytes

Using the software amount (that computers use), how many bytes are in a Megabyte?

• 1000
• 1024^2
• 1000^2
• 1024

Bit Examples (2)

Which of the following can be considered to be a number in binary? Please choose all that apply.

• 1000110
• 11
• FFFFFF
• 301
• DECAF

Bits in a Byte

How many bits make up a byte?

• 2
• 4
• 6
• 8
• 1024

Base 2

Binary is a base 2 numbering system

• True
• False

Converting binary

Binary can be converted to any other numbering system (such as decimal or hexadecimal), with some amount of effort

• True
• False

Number of bits

A number N represented in binary requires log₂(N) bits whereas the same number in decimal requires log₁₀(N) digits.

• True
• False

mv File Rename

Within your home directory, there is a file named first.txt. How would you rename this file to second.txt? You are located in your home directory.

• rm first.txt second.txt
• mv first.txt second.txt
• mv second.txt first.txt
• rename first.txt second.txt
• None of these

mv File Rename2

Which command would rename the file cows.txt to cheezburger.txt?

• rename cows.txt
• rn cows.txt cheezburger.txt
• rm cows.txt
• mv cows.txt cheezburger.txt
• I can haz cheezburger!

mv File Syntax

You are currently located in the E 115 course locker and inside this directory there is a file called play.txt. How would you move this file to your home directory?

• mv play.txt ~/
• move play.txt ~/
• mv ~/ play.txt
• I cannot move that file
• None of these

mv File Syntax – General

The proper syntax for the mv command is ______

• mv oldfile.txt
• mv newfile.txt
• mv oldfile.txt newfile.txt
• mv

mv Function

The mv command can be used to _____

• rename a file
• create a file
• open a file
• None of These

mv Syntax2

Does this syntax work for moving a file, assuming file.txt is in your current working directory? 

mv file.txt ~/MyE115

• Yes
• No

2-FA

NC State students must be enrolled in 2 factor authentication to secure their accounts.

• True
• False

Duo 2-FA Prompt

NC State uses Duo for 2 factor authentication with Shibboleth. Once you log in on Shibboleth, you could be prompted to use a text message code to finalize the log in.

• True
• False

Password Reset

If you forget your password, you can simply reset it via an online system.

• True
• False

Security Terms 1 (5)

Match the following security terms with their definition.

• • When malware takes advantage of security flaws in your programs to download to your computer without your permission.

• • A serious security flaw for which no fix exists. Hackers can find and use it before the developer can release a patch, because there is no fix

• • A secret entrance to your computer that lets someone bypass your security. These usually come from program flaws or are intentionally built in by the developer.

• • An advanced type of virus that replicates and spreads with little or no action on your part.

• • A collection of computers that has been infected with a specialized virus, usually a worm. The worm can control any infected computers, which are then sometimes referred to as “zombies”.

Security Terms 2 (5)

Match the following security terms with their definition.

• • Looks like something trustworthy, but when you download it to your computer, it turns out to be malware. This can be done by hiding or misrepresenting a file extension.

• • When one of these gets into your computer, a hacker can do almost anything to your machine. It can also be extremely difficult to detect and remove.

• • Sometimes also referred to as “Scareware”, this type of malware spooks you into parting with actual money, and can take many forms. A common form is a fake anti-virus program that claims you have many viruses and must pay for the full version to get rid of them.

• • Focused specifically on gathering information about you. Think: data mining.

• • A program that copies everything you type and saves it to a file or sends the data to the owner. Technically considered an advanced form of spyware. Normal security software might not be able to shut them down, but they are usually operated by someone in the household or legally by employers.

2FA

What is two factor authentication?

• using two passwords

• Using two different types of authentication factors

• Using a username and a password

• Using biometrics

3 types of authentication factors

What are the three types of authentication factors?

• knowledge, possession, inherence

• username, password, biometrics

• encryption, decryption, hashing

• username, password, one-time password

Keyloggers

Why does encrypting data between a client machine and server not protect against keyloggers?

•  Because keyloggers can decrypt data

• Because keyloggers intercept keyboard input before encryption

• Because keyloggers are immune to encryption protocols

• Because keyloggers alter data packets in transit

Keylogging

What attack method involves intercepting keyboard input?

• phishing

• keylogging

• spoofing

• tampering

keylogging is

What is keylogging?

• Capturing keystrokes to steal credentials

• Trying all possible passwords

•  Intercepting SMS messages

• Phishing for credentials

Phishing

Falsely claiming to be a legitimate company over the internet in order to scam the consumer is an unethical practice known as:

• Phishing
• Hooking
• Hunting
• Trashing
• Pharming
• None of these

Phishing defense

Which of the following would help you defend against phishing?

• using short passwords

• checking the URL of a website

• sharing passwords

• using the same password for all accounts

Phishing for Passwords

Suppose you get the following email (screenshot below) that asks you to follow a link to change your password. What security threat is this an example of?

• adware

• rootkit

• phishing

• botnet

Threat of phishing

Which threat involves tricking users into giving away their credentials?

• phishing

• keylogging

• tampering

Two Factor

Which services do NCSU recommend for Two-Factor Authentication for user accounts? [Choose all that apply]

• Duo

• Google 2-Step

• Duality

• Another not listed

NCSU Antivirus

NCSU provides free antivirus software to students.

• True
• False

NCSU Antivirus Req

If you are connected to the NCSU network, you are required to have antivirus software running on your computer.

• True
• False

NCSU Antivirus Req2

As an NCSU student, having antivirus software is optional.

• True
• False

OS Updates

It is important that Operating Systems are updated regularly.

• True
• False

OS Virus

All operating systems are vulnerable to a virus attack.

• True
• False

Abs Pathname – Course Locker

What is the absolute path to the E 115 course locker? (Hint: spelling and case matter)

• Answer____________________________

Abs Pathname – Home Dir

If a student’s Unity ID is jshmoe, what would be the absolute path to his home directory?

• Answer____________________________

SSH

NCSU’s Network File System (NFS) is a remote system that you can access (via Terminal or PuTTY) using what protocol? Hint: this protocol has the ability to “tunnel” information and applications through a host.

• Answer____________________________

Reminder about Essays

Please note… all “essay” questions must be answered in your own words. Copying and pasting from the E 115 Online Textbook, any posted slides, or any other material that is not from your own brain will result in a 0 on the question and will be sent in as an Academic Integrity violation.

Accessing NCSU’s Network File System (NFS)

NCSU’s Network File System (NFS) is a remote system that can be accessed using tools like SSH, PuTTY, or similar applications. Describe the process of accessing the NFS using SSH or PuTTY. Discuss the steps involved and any considerations for securely accessing the NFS.

Basic UNIX GL

Please submit the log file you completed during your Basic UNIX Guided Lab here.

Enhancing Security with Duo Authentication

Discuss using Duo Authentication as a form of two-factor authentication and explain: how does two-factor authentication contribute to strengthening account security?

Black Hex Code

In my XHTML code I want to have black text. So I write:

<p style=”color: ___________ “> …

• Answer____________________________

Blue Hex Code

In my HTML code I want to have blue text. So I write:

<p style=”color: ___________ “> …

• Answer____________________________

Green Hex Code

In my HTML code I want to have green text. So I write:

<p style=”color: ___________ “> …

• Answer____________________________

Red Hex Code

In my XHTML code I want to have red text. So I write:

<p style=”color: ___________ “> …

• Answer____________________________

White Hex Code

In my XHTML code I want to have white text. So I write:

<p style=”color: ___________ “> …

• Answer____________________________

man cp

What would you enter into terminal if you want to learn more about the command that copies files and directories?

• Answer____________________________

man ls

What would you enter into terminal if you wanted to know more about the ls command?

• Answer____________________________

man mv

What would you enter into terminal if you wanted to learn more about the command that moves files and directories?

• Answer____________________________

man pwd

What would you enter in terminal if you wanted to learn more about the pwd command?

• Answer____________________________

man script

What would you enter into terminal if you wanted to know more about the script command?

• Answer____________________________

pwd

What would you enter into terminal if you wanted to know what directory you were located in?

• Answer____________________________

pwd output

What would be the output of the pwd command if you were located in the directory in red?

• Answer____________________________

pwd output 2

What would be the output of the pwd command if you were located in the directory in red?

• Answer____________________________

pwd output 3

What would be the output of the pwd command if you were located in the directory in red?

• Answer____________________________

cd example 1

What would you enter into terminal if you wanted to go to the red directory (you can assume you are currently in the green directory)? You can use either relative or absolute file paths.

• Answer____________________________

cd example 2

What would you enter into terminal if you wanted to go to the red directory (you can assume you are currently in the green directory)?

• Answer____________________________

cd example 3

What would you enter into terminal if you wanted to go to the red directory (you can assume you are currently in the green directory)?

• Answer____________________________

ls example 1

Based off the file tree pictured below, what would you enter into terminal to get the following output using the ls command, no matter where you are in the file tree?:

cake.docx
pie.docx

• Answer____________________________

ls example 2

Based off the file tree pictured below, what would you enter into terminal to get the following output using the ls command, no matter where you are in the file tree?:

AutoDesk
Microsoft Office

• Answer____________________________

ls example with option

Based off the file tree pictured below, what would you enter into terminal to get the following output using the ls command, no matter where you are in the file tree?:

drwxr-xr-x  2 unityID ncsu      2048 Apr 25  2015 Paychecks

drwxr-xr-x  2 unityID ncsu      2048 Nov  4  2015 School

• Answer____________________________

ls number of outputs 1

How many file/directory names will be displayed when you run the ls command? You are currently in the green directory.

• Answer____________________________

ls number of outputs 2

How many file/directory names will be displayed when you run the ls command? You are currently in the green directory.

• Answer____________________________

mkdir example 1

What would you enter into terminal to create a folder called Bills in the Important directory? The command should work no matter where you are in the file tree.

• Answer____________________________

mkdir example 2

What would you enter into terminal to create a folder called Pictures in the Documents directory? The command should work no matter where you are in the file tree.

• Answer____________________________

mkdir example 3

What would you enter into terminal to create a folder called Test_files in the AutoDesk directory? The command should work no matter where you are in the file tree.

• Answer____________________________

cp example 1

What would you enter into terminal if you wanted to copy cat.jpg into the Important directory?  You should be able to execute this command from anywhere in the file tree.

• Answer____________________________

cp example 2

What would you enter into terminal if you wanted to copy pie.docx into the Microsoft_Office directory and rename it pie_recipe.docx?  You should be able to execute this command from anywhere in the file tree.

• Answer____________________________

cp example 3

What would you enter into terminal if you wanted to copy the directory Recipes into the Important directory?  You should be able to execute this command from anywhere in the file tree.

• Answer____________________________

mv example 1

What would you enter into terminal if you want to move the cake.docx file into the Documents directory? You can assume you are already in the “Recipes” directory.

• Answer____________________________

mv example 2

What would you enter into terminal if you want to move the Recipes directory into the Documents directory? You should be able to execute this command from anywhere in the file tree.

• Answer____________________________

rm example 1

What would you enter into terminal if you wanted to remove the cat.jpg file?  You should be able to execute this command from anywhere in the file tree.

• Answer____________________________

rm example 2

What would you enter into terminal if you wanted to remove the Recipes directory?  You should be able to execute this command from anywhere in the file tree.

• Answer____________________________

script example 2

What would you type into terminal to continue recording on a log file named e115log.txt, after you previously exited it? Make sure to follow the E 115 guidelines for recording to a log file.

• Answer____________________________

Match Shells to Operating Systems

Write the letter (A or B) next to each shell below.

Match Web Technologies

Match the descriptions to the appropriate web technologies. Write the letter (A, B, or C) next to each description.

Wireless Std Frequencies (4)

Match the wireless standard with its frequency. Write the letter (A or B) next to each standard.

Cables Max Length

What is the correct order of these cables from longest maximum length (length possible before signal loss is experience) to shortest?

• CAT5 (Twisted Pair Cable), Fiber Optic Cable, Coaxial Cable
• CAT5 (Twisted Pair Cable), Coaxial Cable, Fiber Optic Cable
• Fiber Optic Cable, Coaxial Cable, CAT5(Twisted Pair Cable)
• Fiber Optic Cable, CAT5(Twisted Pair Cable), Coaxial Cable

Center Align Example

Which of the following should you use to begin a paragraph with its text center-aligned?

• <center><p>
• <p align=”center”>
• <p align=”middle”>
• <p “center”>
• <p style=”text-align: center”>

Class Selector

Which of the following lets us identify a group of tags with a selector?

• ID
• Category
• Group
• Class
• Identify

Counta

I want to count only the cells within a range that store a mixture of character and numerical data. Which single function would be the best for me to use?

• count
• counta
• countif
• sumif

cp File Syntax3

Which command would copy the file cows.txt from the common/assignments/basicunix directory of the E115 course locker and put it in your home directory? (Assume you are already in the E115 course locker)

• cp cows.txt ~/
• cp common/assignments/basicunix ~/
• cp common/assignments/basicunix/cows.txt ~/
• mv common/assignments/basicunix/cows.txt ~/
• I cannot copy that file

DHCP Addressing

Which of the following automates the assignment of IP addresses, subnet masks, gateways, and other IP parameters?

• RDP
• VCL
• DNS
• DHCP
• IP

Firewall Definition

Which piece of hardware (or software) is designed to prevent intruders and software alike from entering a computer?

• Hub
• Firewall
• Router
• Switch
• None of these

Formatting Tags

Which of the following uses formatting tags to make a few words in the middle of a specific sentence italic, bold and/or underlined?

• <strong><em><ins>
• <p style=”text-decoration: underline; font-weight:bold; font-style:italic;”>
• <p style=”text:strong,em,ins”>
• <font bold, italic, underline>
• Highlight the word and ctrl + b + u + i

• <b><i><u>

GUI Input (2)

Consider a computer that only has a Graphical user interface.  How would this computer receive input? Choose all that apply.

• Mouse click
• Keyboard
• Command line

Hex Primary Colors (3)

In an additive color system (the type used by hex color codes), what are the three primary colors? Choose all that apply.

• Red
• Green
• Yellow
• Blue
• Orange
• Purple
• White
• Black

ins

Inserted text tags are used to ____

• bold an element
• underline an element
• emphasize an element
• strike through an element

IPv6 Bits

How many bits are in an IPv6 address?

• 32
• 64
• 128
• 256

LAN Definition

What does LAN stand for?

• Local Area Network
• Local Area Navigation
• Local Average Network
• Local Average Navigation
• None of these

Link Types (3)

Select the three types of links. Choose all that apply.

• text
• picture
• email
• table

• movie

ls Syntax

Which of the following is NOT a valid example of the List Directory (ls) command?

• ls -a
• ls
• ls ./pathway/to/directory
• ls – ~/

Multi-Computer Network

Which of the following are needed for a network with more than one computer?

• Router
• Wireless Access Point
• Network-based firewall
• Ethernet switch
• None of these

NAT Definition

What does NAT stand for?

• Natural Address Translator
• Network Address Translation
• Neural Allocator for Transmutation
• Network Addressor Tidbit
• Does not stand for anything

Parent and Child

The users directory in the NFS file tree is considered a…

• Root
• Parent
• Child
• Root and Parent
• Parent and Child

PS/2

Before the popularity of USB which port, developed by IBM, was used to connect keyboards and mice?

• Parallel
• PS/2
• Serial
• VGA

• None of these

Rel Pathname – Home Dir

What is the pathname for your home directory?

• ./
• ../
• ~/
• /
• None of these

Rel Pathname – Home Dir3

What does ~/ stand for?

• Home directory
• Your friend’s home directory
• Parent directory
• Your mom’s directory
• Current working directory

Scheduling

What term is used to identify the process in which certain programs have priority for the processor, in other words, sets up a queue?

• Multi-tasking
• Shell
• Control bus
• Scheduling
• None of these

Security Threat

What poses the greatest threat to a computer?

• virus
• spyware
• your mother
• adware

Serial

This port was as universal in the 1980’s as the USB port is today.

• Serial
• PS/2
• USB
• Parallel

Shareware2

If you were to buy a new laptop and you received a trial version of Microsoft Office, what kind of license would that be?

• Freeware
• Shareware
• Network
• Alpha
• Buyware

Styling Example

Select the appropriate XHTML coding for this: 52₁₀*4³

• 52₁₀*4³
• 52¹⁰*4₃
• ⁵²10*₄3
• None of These

Sum Syntax

Which of the following is the correct syntax, using a function, for determining how much a given range adds up to?

• =count(A9:A29)
• =E10+E11+E12+E13+E14+E15+E16+E17+E18+E19…+E29
• =sum(E10:E29)
• sum(E10:E29)
• None of these

Switch Control

Which of the following devices has more control over which computers receive which data?

• Switch
• Hub
• Node
• Mouse
• CPU

VGA2

Which port was used exclusively for video with older monitors?

• Modem
• Ethernet
• VGA
• DVI
• HDMI

Win 10 + Putty Interface

Microsoft Windows 10, running Putty, provides what kind of interaction with the user?

• GUI-based
• Command Line-based
• Hybrid (GUI + CLI)
• None of these
• CLI

IF Output3

What would be the result of this IF statement?

• Answer____________________________

Mini-Display Port

Based on the following image, which port is this?

• Answer____________________________

Exe Safety

You should always open a .exe file because it contains safe information for your computer.

• True
• False

Leaf 2

A leaf node has a parent.

• True
• False

Nested IF T/F2

The following equation is a valid example of nested IF functions. =IF(C10=“breakfast”, breakfastPrice, C10=“lunch”, lunchPrice, C10=“dinner”, dinnerPrice)

Note: “breakfastPrice”, “lunchPrice”, and “dinnerPrice” are names of cells that contain numerical data

• True
• False

Protection Req

To protect your computer, you need updated Antivirus software and OS updates turned on.

• True
• False

RAM vs ROM T/F

RAM is writable memory that is considered to be volatile (loses data upon power loss) while ROM is not writable, non-volatile memory that generally contains the BIOS.

• True
• False

GitHub vs FTP

Which of the following correctly compares NCSU GitHub Enterprise with file transfer systems like FileZilla?

• NCSU GitHub Enterprise is designed for version control and collaboration, while FileZilla focuses on file transfers between a local system and a remote server.

• FileZilla offers version control features, but NCSU GitHub Enterprise does not.

• Both systems are equally suitable for managing large collaborative coding projects.

• NCSU GitHub Enterprise is limited to those with NCSU UnityIDs, while FileZilla can connect to any server with appropriate credentials.

• FileZilla encrypts all transferred files by default, whereas GitHub Enterprise does not.

Version Control

You don’t want to save multiple nearly-identical versions of the same document. How can GitHub help you with keeping your version history?

• version control

• file extensions

• commit

• cloning a repository

57 Convert 

Write 57 as a sum of powers of 2 .

____________________ 

67 Convert 

Write 67 as a sum of powers of 2.

____________________ 

75 Convert 

Write 75 as a sum of powers of 2.

____________________________

83 Convert

Write 83 as a sum of powers of 2.

__________________